Overview:
Basic PostgreSQL Troubleshooting
PostgreSQL Still Doesn't Work (Read the FAQ Below First)
Delete Postmaster.pid file
Please delete the C:\Program Files\postgresql\8.x\data\postmaster.pid file, if you see it. The file may not be there but please Do Not delete any other files with similar names
Quick Solution
Many of the past compatibility problems associated with Windows and PostgreSQL can be solved by using our latest Combo installer. (Download Combo Installer) This installer will rename your old PostgreSQL folder so you may have to reimport your hands once you've fixed your PostgreSQL problem. If you want to try and solve the problem without losing your database, read the rest of this FAQ.
This FAQ is for any of the following PostgreSQL problems:
- Failed to establish a connection to ‘127.0.0.1’ Service 'PostgreSQL Database Server 8.x' (pgsql-8.x) failed to start. Verify that you have sufficient privileges to start system services
- Unable to read data from the transport connection: An existing connection was forcibly closed by the remote host
- The PostgreSQL Database service started then stopped, Some services stop automatically if they have no work to do...
- Windows just updated and PostgreSQL doesn't work anymore
- Or any PostgreSQL type error when trying to open Holdem Manager
Basic PostgreSQL Troubleshooting
Note: Make sure (UAC) User Account Control is off before proceeding. See the following links for information about UAC.
- Windows 7 UAC Help
- Vista UAC Help
Restart PostgreSQL service & Reboot
Go to Start > Programs > PostgreSQL > 8.x > Stop Service (If its already started)
Then go to Start > Programs > PostgreSQL > 8.x > Start Service
If that doesnt help delete the C:\Program Files\postgresql\8.x\data\postmaster.pid file (it may not be there, that is perfectly fine)
Finally, if none of the above works a simple reboot can often resolve the issue
99% of the time PostgreSQL connection problems can be fixed by completely uninstalling software security products.
We suggest you completely uninstall: (Don't just disable these products!!!) Disabling these products doesn't work because they are still running in the background. Reboot after uninstall too.
- Antivirus (Avast & AVG are free solutions with no known problems)
- Spyware Tools
- 3rd Party Firewalls
Note: Mcaffe, Comodo, F-Secure, Panda and Norton are the worst offenders here. If you are getting the errors and have 1 or more of these products installed, there is a very good chance that once these Antivirus programs are completely removed from your PC, PostgreSQL and Holdem Manager will be working together again.
Note: If you're a Software Security nit, chances are you have a couple antivirus programs with a couple spyware programs. Uninstall everything for now.
Note: Once PostgreSQL is working, we can install Software Security programs, but only 1 at a time testing our PostgreSQL connection each time.
Logon using Local System Account:
1. Go to Start / Control Panel / Administrative Tools (Need to be using classic view in Windows Vista) / Services. The Services dialog will pop up.
2. Scroll to PostgreSQL Database Server. If it isn't started (as indicated in the status column) right click on it and choose Start. If it starts and then stops or was already started, follow the steps below:
3. Right click on PostgreSQL Database Sever and choose Properties. You should see the following dialog.
4. Click on the Log On tab. Copy the username in the This Account field and paste it into Notepad in case you need to use it again. Make sure you know your password as well.
5. Select Local System Account and then click Apply then OK.
6. Restart your PC and see if you still get the error.
7. If it does not fix it, please switch to logon as This Account and enter your username and password again and reboot and continue with the rest of the FAQ.
Testing PostgreSQL Connection:
While there's multiple ways to do this, the easiest is to just open Holdem Manager.
-
Launch Holdem Manager
If Holdem Manager opens you are done.
If you still get a PostgreSQL error, PostgreSQL is not connected or working.
Still Not Working?
Now we need to rule out the following:
Fresh Reinstall of PostgreSQL
I’ve listed 3 PostgreSQL forums below:
Check Secondary Installer Service is running:
You need to start it via control panel > administrative tools > services. Starting it once should insure it works in the future also.
If that also fails Please follow step A again and try this version - http://ftp.postgresql.org/pub/binary/v8.2.23/win32/postgresql-8.2.23-1.zip